package cn.siat.gene.mapper;

import cn.siat.common.core.web.domain.AjaxResult;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import cn.siat.gene.domain.Programme;
import cn.siat.gene.domain.vo.ProgrammeVO;
import cn.siat.gene.domain.dto.ProgrammeQueryParam;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * @Description: 方案信息
 * @Author: Administrator
 * @Date:   2022-10-22
 * @Version: V1.0
 */
@Mapper
public interface ProgrammeMapper extends BaseMapper<Programme> {

    List<ProgrammeVO> queryProgrammeList(ProgrammeQueryParam queryParams);

    List<ProgrammeVO> listNoProjectProgrammes(Programme programme);

    List<Map<String, String>> selectProgrammeCreateStaffList(String possessStaff);

    int updateExamineState(Programme programme);

    @Select("SELECT COUNT(*) FROM programme WHERE programme_Name = #{programmeName}")
    int existById(@Param("programmeName") String programmeName);
}
